vaccinatorfieldplan

Table: vaccinatorfieldplan

The vaccinatorfieldplan table stores information about the planned field visits of vaccinators, including coverage area, date, and associated staff.

Columns

Column Name	Data Type	Constraints	Description
vaccinatorFieldPlanId	int(11)	NO	Primary key identifying each field plan
catchmentPopulation	varchar(255)	YES	Population covered in the field plan area
createdDate	datetime	YES	Timestamp when the field plan was created
fieldDate	date	YES	Date of the planned field visit
fieldVisitArea	varchar(255)	YES	Area where the field visit is scheduled
isLhwAccompanied	tinyint(1)	YES	Flag indicating if a Lady Health Worker (LHW) is accompanying
lastEditedDate	datetime	YES	Timestamp when the record was last edited
lhwName	varchar(255)	YES	Name of the accompanying LHW, if any
mappedId	int(11)	NO	Reference to the vaccinator’s mapped ID
voided	tinyint(1)	YES	Flag indicating if the record is voided
voidedDate	datetime	YES	Timestamp when the record was voided
voidedReason	varchar(255)	YES	Reason for voiding the record
createdByUserId	int(11)	YES	User who created the record
editedByUserId	int(11)	YES	User who last edited the record
idMapper_mappedId	int(11)	YES	Reference ID from idmapper, if applicable
vaccinatorId	int(11)	YES	Reference to the vaccinator

Indexes

• vaccinatorFieldPlanId_createdByuser_fk — Index on createdByUserId
• vaccinatorFieldPlan_editedByuser_fk — Index on editedByUserId
• vaccinatorFieldPlan_mappedId_pk_fk_idx — Index on mappedId
• vaccinator_fieldPlan — Index on vaccinatorId

Foreign Key Relations

• createdByUserId → user.mappedId
• editedByUserId → user.mappedId
• vaccinatorId → vaccinator.mappedId

Usage Notes

• Defines vaccinator field visit schedules and assignments.
• Tracks coverage areas and staff involvement (e.g., LHW accompaniment).
• Used for planning, monitoring, and auditing field vaccination activities.